package com.yixin.mapper;

import com.yixin.entity.SmallCompany;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface SmallCompanyMapper {
//    @Select("select id, name, user_name, phone, phone2, address, identity, company_code, area, tax_password, need_seal, tax, ticket_type, expire_date, work_type, remark, proxy_date_start, proxy_date_end, document_desc, contact_person, bank_info, bank_account, bank_info2, bank_account2, has_license, license_location, has_seal, seal_location, is_quota, quota_value, is_del, create_time, update_time from small_company where is_del = 0 order by create_time desc")
//    List<SmallCompany> findAll();
//
//    @Insert("insert into small_company (name, user_name, phone, phone2, address, identity, company_code, area, tax_password, need_seal, tax, ticket_type, expire_date, work_type, remark, proxy_date_start, proxy_date_end, document_desc, contact_person, bank_info, bank_account, bank_info2, bank_account2, has_license, license_location, has_seal, seal_location, is_quota, quota_value, is_del, create_time, update_time) values (#{name}, #{userName}, #{phone}, #{phone2}, #{address}, #{identity}, #{companyCode}, #{area}, #{taxPassword}, #{needSeal}, #{tax}, #{ticketType}, #{expireDate}, #{workType}, #{remark}, #{proxyDateStart}, #{proxyDateEnd}, #{documentDesc}, #{contactPerson}, #{bankInfo}, #{bankAccount}, #{bankInfo2}, #{bankAccount2}, #{hasLicense}, #{licenseLocation}, #{hasSeal}, #{sealLocation}, #{isQuota}, #{quotaValue}, #{isDel}, #{createTime}, #{updateTime})")
//    void add(SmallCompany smallCompany);
//
//    @Update("update small_company set name = #{name}, user_name = #{userName}, phone = #{phone}, phone2 = #{phone2}, address = #{address}, identity = #{identity}, company_code = #{companyCode}, area = #{area}, tax_password = #{taxPassword}, need_seal = #{needSeal}, tax = #{tax}, ticket_type = #{ticketType}, expire_date = #{expireDate}, ")
//    void update(SmallCompany smallCompany);

    List<SmallCompanyMapper> findPage(SmallCompany smallCompany);

    void add(SmallCompany smallCompany);
}
